Records(FCSQLExec)

Object and Type

Object  : FCSQLExec

Type     : Property

Prototype

Public Records As ADODB.RecordSet

Description

This property contains the data records for the SQLExec object. The records are stored in an ADODB.Recordset object.

The records are created by using the ExecuteReturnRecords method.

In almost all cases, you do not need to ever worry about creating a Records object for a SQLExec object. When you create the object, the Records object is created for you automatically.

Data is read and written from the Records object using standard ADO methods. No additional methods are provided.

Note: For more information about ADODB Recordsets, please visit the Microsoft website at: http://www.microsoft.com/.

Example

The following example demonstrates querying the case table, and setting the alt_address field for each object returned, using the Records property, but not with the generic object, but a SQLExec object.

JavaScript:

The code in this example is written in JavaScript for inclusion in ASP pages.

  // Create an external DB connection

  // Log in

  var SqlDB = FCSession.CreateSQLExec();

  SqlDB.OpenConnection("sql", "sa", "sa", "gaffer", "cl10");

  // Query for a simple table (with one column)

  // Iterate through it and print out the data

  SqlDB.ExecuteReturnRows("select * from table_case");

  while (SqlDB.Records.EOF != true)

  {

    SqlDB.Execute("update table_case set alt_address = 'Alt1' where"

                  " objid = " + SqlDB.Records("objid"));

    SqlDB.Records.MoveNext();

  }

  SqlDB.CloseConnection();

Visual Basic:

The code in this example is written in Visual Basic.

  Dim SqlDB As New FCSqlExec

  Set SqlDB = fc_session.CreateSqlExec

  SqlDB.OpenConnection "sql", "sa", "sa", "gaffer", "cl10"

  SqlDB.ExecuteReturnRows "select * from table_case"

  While SqlDB.records.EOF = False

    SqlDB.Execute "update table_case set alt_address = 'Alt2' " & _

                  "where objid = " & _

                  Trim$(Str$(SqlDB.records("objid")))

    SqlDB.records.MoveNext

  Wend

  SqlDB.CloseConnection